[dbo].[BAEOrderProductGetAvailableInventory]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEOrderProductGetAvailableInventory

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@ProductCode	varchar(50)	50

SQL Script

create procedure [dbo].[BAEOrderProductGetAvailableInventory] @ProductCode varchar(50) as
SELECT QUANTITY_AVAILABLE  AS 'QuantityAvailable'
    FROM Product_Inventory
    WHERE PRODUCT_CODE = @ProductCode

GO

Uses

[dbo].[Product_Inventory]
dbo